package com.so206.mapper;

import com.so206.po.SystemUser;
import org.apache.ibatis.annotations.Mapper;
import org.apache.ibatis.annotations.Param;

import java.util.List;

@Mapper
public interface SystemUserMapper {
    int deleteByPrimaryKey(Long id);

    int insert(SystemUser record);

    int insertSelective(SystemUser record);

    SystemUser selectByPrimaryKey(Long id);

    int updateByPrimaryKeySelective(SystemUser record);

    int updateByPrimaryKey(SystemUser record);

    List<SystemUser> selectByUserParent(@Param("model_uid") Long model_uid);

    List<SystemUser> selectByUserIsLocked(@Param("user") String user, @Param("lck") Integer lck);

    List<SystemUser> selectByPhone(@Param("phone") String phone);

    List<SystemUser> selectByEmail(@Param("email") String email);

    List<SystemUser> selectByUserIdRoleEmailUserParent(@Param("user") String user, @Param("pid") Long pid, @Param("role") Long role, @Param("email") String email, @Param("parent_id") Long parent_id);

}